# create_rs_data_tables = [
#     'CREATE TABLE modis'
#     '('
#         'data_id int identity(1,1) primary key,'
#         'sat_category int,'
#         'product_category VARCHAR(255),'
#         'observation_date date,'
#         'observation_day_of_year int,'
#         'horizontal int,'
#         'vertical int,'
#         'create_date date,'
#         'file_path VARCHAR(255),'
#         'file_version int'
#     ')',
#
#     'CREATE TABLE landsat'
#     '('
#         'data_id int identity(1,1) primary key,'
#         'sat_category int,'
#         'sat_path int,'
#         'sat_row int,'
#         'observation_date date,'
#         'observation_day_of_year int,'
#         'data_category VARCHAR(255),'
#         'data_band_least int,'
#         'data_band_most int,'
#         'file_path VARCHAR(255)'
#     ')',
#
#     'CREATE TABLE dem'
#     '('
#         'data_id int identity(1,1) primary key,'
#         'data_latitude int,'
#         'data_longitude int,'
#         'data_latitude_type VARCHAR(255),'
#         'data_longitude_type VARCHAR(255),'
#         'data_level VARCHAR(255),'
#         'data_resolution int,'
#         'file_path VARCHAR(255)'
#     ')',
#
#     'CREATE TABLE ear5'
#     '('
#         'data_id int identity(1,1) primary key,'
#         'observation_date date,'
#         'file_path VARCHAR(255),'
#     ')',
#
# ]

create_rs_data_tables = [
    'CREATE TABLE modis'
    '('
        'data_id int primary key auto_increment,'
        'sat_category int,'
        'product_category VARCHAR(255),'
        'observation_date date,'
        'observation_day_of_year int,'
        'horizontal int,'
        'vertical int,'
        'create_date date,'
        'file_path VARCHAR(255),'
        'file_version int'
    ')',

    'CREATE TABLE landsat'
    '('
        'data_id int primary key auto_increment,'
        'sat_category int,'
        'sat_path int,'
        'sat_row int,'
        'observation_date date,'
        'observation_day_of_year int,'
        'data_category VARCHAR(255),'
        'data_band_least int,'
        'data_band_most int,'
        'file_path VARCHAR(255)'
    ')',

    'CREATE TABLE dem'
    '('
        'data_id int primary key auto_increment,'
        'data_latitude int,'
        'data_longitude int,'
        'data_latitude_type VARCHAR(255),'
        'data_longitude_type VARCHAR(255),'
        'data_level VARCHAR(255),'
        'data_resolution int,'
        'file_path VARCHAR(255)'
    ')',

    'CREATE TABLE ear5'
    '('
        'data_id int primary key auto_increment,'
        'observation_date date,'
        'file_path VARCHAR(255)'
    ')'

]

insert_data_into_tables = {
    "modis" : 'INSERT INTO modis(sat_category, product_category, observation_date, observation_day_of_year, horizontal, vertical, create_date, file_path, file_version)'
    'VALUES (%d, %s, %s, %d, %d, %d, %s, %s, %d)',
    "landsat": 'INSERT INTO landsat(sat_category, sat_path, sat_row, observation_date, observation_day_of_year, data_category, data_band_least, data_band_most, file_path)'
    'VALUES (%d, %d, %d, %s, %d, %s, %d, %d, %s)',
    "dem": 'INSERT INTO dem(data_latitude, data_longitude, data_latitude_type, data_longitude_type, data_level, data_resolution, file_path)'
    'VALUES (%d, %d, %s, %s, %s, %d, %s)',
    "ear5": 'INSERT INTO ear5(observation_date, file_path) VALUES (%s, %s)'
}